package com.int_tech.car.dao;

import com.int_tech.car.entity.CarInfoData;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.Date;
import java.util.List;

/**
 * Created by liubch on 2017/11/21.
 */
public interface CarInfoDataDao extends JpaRepository<CarInfoData,Integer> {
    List<CarInfoData> findByCarNumber(String carNumber);

    List<CarInfoData> findByStationId(int stationId);

    CarInfoData findByUnKey(String unkey);

    List<CarInfoData> findByCarNumberAndCreateTimeAfterAndCreateTimeBefore(String carNumber, Date sDate, Date eDate);

    List<CarInfoData> findByStationIdAndCreateTimeAfterAndCreateTimeBefore(int stationId, Date sDate, Date eDate);

    List<CarInfoData> findByLeisureTimeLessThan(float i);


//    List<CarInfoData> findByCarNumberAndTimeDateAfterAndTimeDateBefore(String carNumber, Date sDate, Date eDate);
}
